Ryan Sides Community Champion

Overview

Overview

Email	rsides27@gmail.com
Roles	Member
Badges	25

About Me

About Me

Area of Expertise	Business Process Improvement; using Smartsheet to it's full capabilities. Control Center, Data Shuttle/Mesh, Dynamic View, Resource Management, and others.
About Me	I help organizations of various sizes get the most from their Smartsheet licenses.
How I Use Smartsheet	As a consultant helping others. Feel free to drop me a line. I'm always glad to help!
Linkedin	https://www.linkedin.com/in/business-operations-consultant-coach/

Analytics

516

Posts

540

Visits

1.6k

Points

May 31, 2022

Join Date

Feb 27, 2025

Last Active

Reactions

• Insightful 11

  11
• Vote Up 29

  29
• Awesome 56

  56
• Spam 2

  2

• Activity
• Discussions9
• Comments507

• Re: How can I return the nth value from a multiselect dropdown?

  Ryan Sides

  12/14/22
  Hey @Scott Orsey I've tried something similar with multiselect and came to the same conclusion as you. There's no easy way to do it. I used FIND and helper columns, but even then, it's messy. You can…
  1 ·

• Re: =SUMIFS with Criterion3

  Ryan Sides

  12/14/22
  Hey @Mr. Chris your criteria is missing a match criteria for QD. =SUMIFS([Invoice Amount]:[Invoice Amount], Status:Status, "Approved", [CapEx #]:[CapEx #], [CapEx Number]@row, [QD]:[QD], yo…
  1 ·

• Re: Dynamic Cell reference in MAX() formula

  Ryan Sides

  12/06/22
  @Andrew Stills Your current update to the helper column is being captured as a "change" to the row. Try switching your "bump" automation to lock and unlock rows at a certain time …
  1 ·

• Re: Total COUNTIFs within the last 30 days with two columns of data

  Ryan Sides

  12/07/22
  @bcrochet Yes! Thanks you for the context. Two ways to do this. 1) On your second sheet, you can use the following formula and replace each name as needed... =COUNTIFS({AUDITOR NAME Range}, "Rya…
  1 ·

• Re: Using Count & Distinc formulas to

  Ryan Sides

  12/06/22
  Hi @Diego Cardenas , give this one a try... =COUNT(DISTINCT(COLLECT([Initial date]:[Initial date], Resp:Resp, "Diego Cardenas"))) This formula will work for your current sheet layout. If yo…
  1 ·

Previous Next